// 系统菜单
const {DataTypes, db } = require("../db");
db.define('menuV5', {
id: {type: DataTypes.INTEGER, primaryKey: true, autoIncrement: true,comment:'表自增ID'},
code:{type: DataTypes.STRING(255),comment:'编码'}, 
name:{type: DataTypes.STRING(50),comment:'栏目名称'}, 
pid:{type: DataTypes.SMALLINT,comment:'上级栏目ID'}, 
sort:{type: DataTypes.SMALLINT,comment:'排序'}, 
routeId:{type: DataTypes.STRING(50),defaultValue:(''),comment:'菜单ID'}, 
icon:{type: DataTypes.STRING(50),defaultValue:(''),comment:'图标'}, 
isDelete:{type: DataTypes.INTEGER,defaultValue:0,comment:'是否删除'}, 
sep:{type: DataTypes.INTEGER,defaultValue:0,comment:'分隔线'}, 
allowAdd:{type: DataTypes.INTEGER,defaultValue:1,comment:'允许新增'}, 
allowEdit:{type: DataTypes.INTEGER,defaultValue:1,comment:'允许编辑'}, 
allowDel:{type: DataTypes.INTEGER,defaultValue:1,comment:'允许删除'}, 
isAdmin:{type: DataTypes.INTEGER,defaultValue:0,comment:'admin用户有权限 的菜单'}, 
isBill:{type: DataTypes.INTEGER,defaultValue:0,comment:'是票据功能菜单'}, 
isReport:{type: DataTypes.INTEGER,defaultValue:0,comment:'是报表功能'}, 
bt:{type: DataTypes.INTEGER,defaultValue:0,comment:'下分隔线'}, 
params:{type: DataTypes.TEXT,comment:'页面参数'}, 
display:{type: DataTypes.INTEGER,defaultValue:1,comment:'是否显示'}, 
page:{type: DataTypes.STRING(100),comment:'页面'}, 
title:{type: DataTypes.STRING(255),comment:''}, 
isMobile:{type: DataTypes.INTEGER,comment:''}, 
path:{type: DataTypes.STRING(255),comment:''}, 
type:{type: DataTypes.STRING(255),comment:''}, 
isPc:{type: DataTypes.INTEGER,defaultValue:1,comment:''}, 
tag:{type: DataTypes.STRING(255),comment:''}, 
addRoute:{type: DataTypes.STRING(255),comment:''}, 
window:{type: DataTypes.INTEGER,defaultValue:0,comment:'可在新窗口打开路由'}, 

}, {
    tableName: 'menu_v5',
    timestamps: false,
    comment: '系统菜单',
    
});